Using Wildcards to search in Accentis Enterprise

The majority of Accentis Enterprise forms and reports allow you to search for specific data. However, when you have a large amount of data, or when you want to see multiple (but not all) results, you might find yourself spending considerable time sifting through results, or searching records one-by-one.

But this is not necessary! All text fields in Accentis Enterprise forms and reports (when the form is in a SEARCH state) support the use of wildcards.

A wildcard is a character that is coded into the program that, when used in a search, will perform a specific function. This can include partial word searching, searching for results containing a specific letter or number, or even searching for results including an exact number of characters before or after a specified term. They can be incredibly useful and, when added to your arsenal, can optimise and streamline your use of Accentis Enterprise.

Below is a list of the wildcard options when searching in Accentis Enterprise:

Partial word searching may be something that you already use, but it is an essential tool to have. When you search for something, all results that begin with that search term will be displayed. This is very useful when you utilise prefixes in your coding schemas, or for batch- and serial-tracked items.

For example, if you search an Inventory report for item codes of "456", you will see every item code that begins with exactly "456", like this:

The asterisk is probably the most commonly used wildcard in Accentis Enterprise. It allows for partial word searching when the exact search term exists anywhere in the result. This is useful in a large range of situations, such as when searching for a Contact record, but you only remember the last three digits of their phone number. This can be used for finding multiple results containing a common term, or it can be used to find a more specific result. This wildcard is used to surround a search term like this: *term*. Some reports will display results without requiring the second asterisk, but it is good practice to use both anyway.

For example, if you got a call from a customer named Mick who gave you a mobile number for a call back that ended in "324", he could be listed in your Contact record as Michael, Mick, Micky, or a number of other names. It could take some time to find his record! However, if you used asterisks to search your Contact form for contacts with both *mic* in the name AND *324* in the phone number, you will likely only see the record you need. Here's an example of this:

The question mark wildcard is similar to the asterisk wildcard, but represents only a single character, rather than any number of characters. This can be extremely helpful if you have a good coding schema and want to find related items.

The question mark can be placed before, after, within, or surrounding a search term. For example, you can use:

For example, if your coding schema dictates that an item is coded as: TTTCCMMM where TTT is the type of item, CC is the colour, and WWW is the item's width in millimetres, you might search for ???GR??? to see all green items using that coding schema, or TUB??00? to see all tubes of any colour that are smaller than 10 mm. This produces more specific results than searching for *GR*, which might also display results such as Plant-Grower and CheeseGraterMetal.

This wildcard is commonly used in conjunction with an asterisk to find records with at least one character before or after the search term. .

Here's a worked example of the question mark and asterisk in use together:

  • You have the following three items:
    • 123-ABC-456
    • ABC-456-123
    • 456-123-ABC
  • These items are all different, but due to the similarities in their coding schemas, searching for *ABC*, *123*, or *456* will display all three results.
  • If you know that items ending in "123" are discontinued, and you want to see item codes that contain "123" anywhere except at the end, you would search *123?*.
  • If you know that the indicator "ABC" has different meanings depending on its position in the item code, and you only want to see item codes with "ABC" in the middle, you would search *?ABC?*.
  • If you know that an item code beginning with "456" indicates that it is a one-off item, and you want to see item codes that contain "456" anywhere except at the beginning, you would search *?456*. Alternatively, if you only wanted to see item codes ending in "456", you would remove the trailing asterisk and search *?456.

Keep in mind that using the question mark wildcard in conjunction with asterisks may negate the number of question marks used. If you search for *?ABC?*, for example, you would see AABC2 and 3ABCA as intended, but you would also see 123ABC456.

The hash wildcard functions the same as the question mark, but represents a single number instead of a single character.

As with the question mark wildcard, the hash can be placed before, after, within, or surrounding a search term.

Last edit: 06/05/2026